Database reverse engineering: From requirements to CARE tools

This paper analyzes the requirements that CASE tools should meet for effective database reverse engineering (DBRE), and proposes a general architecture for data-centered applications reverse engineering CASE environments. First, the paper describes a generic DBMS-independent DBRE methodology, then it analyzes the main characteristics of DBRE activities in order to collect a set of desirable requirements. Finally, it describes DB-MAIN, an operational CASE tool developed according to these requirements. The main features of this tool that are described in this paper are its unique generic specification model, its repository, its transformation toolkit, its user interface, the text processors, the assistants, the methodological control and its functional extensibility. Finally, the paper describes five real-world projects in which the methodology and the CASE tool were applied. This is a heavily revised and extended version of “Requirements for Information System Reverse Engineering Support” by J.-L. Hainaut, V. Englebert, J. Henrard, J.-M. Hick, D. Roland, which first appeared in the Proceedings of the Second Working Conference on Reverse Engineering, IEEE Computer Society Press, pp. 136–145, July 1995. This paper presents some results of the DB-MAIN project. This project is partially supported by the Région Wallonne, the European Union, and by a consortium comprising ACEC-OSI (Be), ARIANE-II (Be), Banque UCL (Lux), BBL (Be), Centre de recherche public H. Tudor (Lux), CGER (Be), Cockerill-Sambre (Be), CONCIS (Fr), D'Ieteren (Be), DIGITAL, EDF (Fr), EPFL (CH), Groupe S (Be), IBM, OBLOG Software (Port), ORIGIN (Be), Ville de Namur (Be), Winterthur (Be), 3 Suisses (Be). The DB-Process subproject is supported by the Communauté Fran?aise de Belgique.     

多媒体教育资源库层次索引模型

依据多媒体教育资源各层次特征及其关系,通过定义资源媒体特征空间,构建了教育资源库层次索引模型,各层次特征间的映射规则将资源的高层语义特征映射到低层媒体特征,达到了扩充描述语义的目的,提高了查全率;结合学科本体,规范了资源标注内容和用户查询条件的描述,减少了人为因素对查询项和索引项匹配相似度计算的影响,提高了查准率.     

期刊发稿动力学系统

发稿库库存量是影响稿件发表时间的关键因素之一,文章分析了影响发稿库库存量的两个指标:一是二审库稿件进入发稿库的入库率,二是发稿库中排队时间为x的稿件的刊登率.最后给出了研究问题的数学描述.     

关系模式关键字的一个求解算法

本文给出了关系数据库模式中求解关键字的一个算法。算法很简洁并且对于[1]定义的一大类问题,执行时间是多项式级的。     

商标数据库存储模式及其检索算法研究

依据商标专家的先验知识和基于内容的图像检索技术，提出了一种新的商标库存储结构，并依据该存储结构设计了以三级检索算法为核心的实用商标登记注册管理系统，对于检索算法，一级检索采用人工确认，二级检索采用傅立叶描述子作为边缘特征向量，三级检索采用hu不变矩组作为矩特征向量，从而达到提高商标申请注册中的检索速度和查准率。     

What to Learn from a Comparative Genomic Sequence Analysis of <Emphasis Type="Italic">L</Emphasis>-Carnitine Dehydrogenase

Summary. In contrast to eukaryotic cells certain eubacterial strains have acquired the ability to utilize L-carnitine (R-(–)-3-hydroxy-4-(trimethylamino)butyrate) as sole source of energy, carbon and nitrogen. The first step of the L-carnitine degradation to glycine betaine is catalysed by L-carnitine dehydrogenase (L-CDH, EC 1.1.1.108) and results in the formation of the dehydrocarnitine. During the oxidation of L-carnitine a simultaneous conversion of the cofactor NAD⁺ to NADH takes place. This catabolic reaction has always been of keen interest, because it can be exploited for spectroscopic L-carnitine determination in biological fluids – a quantification method, which is developed in our lab – as well as L-carnitine production.Based on a cloned L-CDH sequence an expedition through the currently available prokaryotic genomic sequence space began to mine relevant information about bacterial L-carnitine metabolism hidden in the enormous amount of data stored in public sequence databases. Thus by means of homology-based and context-based protein function prediction is revealed that L-CDH exists in certain eubacterial genomes either as a protein of approximately 35 kDa or as a homologous fusion protein of approximately 54 kDa with an additional putative domain, which is predicted to possess a thioesterase activity. These two variants of the enzyme are found on one hand in the genome sequence of bacterial species, which were previously reported to decompose L-carnitine, and on the other hand in gram-positive bacteria, which were not known to express L-CDH. Furthermore we could not only discover that L-CDH is located in a conserved genetic entity, which genes are very likely involved in this L-carnitine catabolic pathway, but also pinpoint the exact genomic sequence position of several other enzymes, which play an essential role in the bacterial metabolism of L-carnitine precursors.     

SciFinder-guided rational design of fluorescent carbon dots for ratiometric monitoring intracellular pH fluctuations under heat shock

Intracellular pH plays a significant role in various biological processes, including cell proliferation, apoptosis, metabolism, enzyme activity and homeostasis. In this work, a novel design strategy for the preparation of pH responsive carbon dots (CDs-pH) for ratiometric intracellular imaging was reported. By using SciFinder database, fluorescent CDs-pH with the required pK_a value of 6.84 were rationally designed, which is vital important for precise sensing of intracellular pH. As a result, the synthesized CDs-pH demonstrated robust ability to test pH fluctuations within the physiological range of 5.4-7.4. The CDs-pH was further utilized for fluorescent ratiometric imaging of pH in living HeLa cells, effectively avoided the influence of autofluorescence from native cellular species. Moreover, real-time monitoring of intracellular pH fluctuation under heat shock was successfully realized. This SciFinder-guided design strategy is simple and flexible, which has a great potential to be used for the development of other types of CDs for various applications.     

A genetic algorithm for the automated generation of molecules within constraints

Summary A genetic algorithm has been designed which generates molecular structures within constraints. The constraints may be any useful function, for example an enzyme active site, a pharmacophore or molecular properties from pattern recognition or rule-induction analyses. The starting point may be random or may utilise known molecules. These are modified to grow into families of structures which, using the evolutionary operators of selection, crossover and mutation evolve to better fit the constraints. The basis of the algorithm is described together with some applications in lead generation, 3D database construction and drug design. Genetic algorithms of this type may have wider applications in chemistry, for example in the design and optimisation of new polymers, materials (e.g. superconducting materials) or synthetic enzymes.